clear all
program drop _all
set more off
set mem 600m

cd "C:\Users\master\Dropbox\Research\mexican_repatriates2\data\kwan"
use "D:\raw\1910.dta"

keep statefip county perwt age

keep if age>=18 & age<=65

replace county = (1000*statefip) + (county/10)

collapse (sum) pop10=perwt, by(county)

*replace county=41061 if county==41060.5

save pop1910.dta, replace 
